insert into states(country_id, long_name, short_name) values(172, 'Abra', 'ABR');
insert into states(country_id, long_name, short_name) values(172, 'Agusan del Norte', 'AGN');
insert into states(country_id, long_name, short_name) values(172, 'Agusan del Sur', 'AGS');
insert into states(country_id, long_name, short_name) values(172, 'Aklan', 'AKL');
insert into states(country_id, long_name, short_name) values(172, 'Albay', 'ALB');
insert into states(country_id, long_name, short_name) values(172, 'Antique', 'ANT');
insert into states(country_id, long_name, short_name) values(172, 'Apayao', 'APA');
insert into states(country_id, long_name, short_name) values(172, 'Aurora', 'AUR');
insert into states(country_id, long_name, short_name) values(172, 'Basilan', 'BAS');
insert into states(country_id, long_name, short_name) values(172, 'Bataan', 'BAN');
insert into states(country_id, long_name, short_name) values(172, 'Batanes', 'BTN');
insert into states(country_id, long_name, short_name) values(172, 'Batangas', 'BTG');
insert into states(country_id, long_name, short_name) values(172, 'Benguet', 'BEN');
insert into states(country_id, long_name, short_name) values(172, 'Biliran', 'BIL');
insert into states(country_id, long_name, short_name) values(172, 'Bohol', 'BOH');
insert into states(country_id, long_name, short_name) values(172, 'Bukidnon', 'BUK');
insert into states(country_id, long_name, short_name) values(172, 'Bulacan', 'BUL');
insert into states(country_id, long_name, short_name) values(172, 'Cagayan', 'CAG');
insert into states(country_id, long_name, short_name) values(172, 'Camarines Norte', 'CAN');
insert into states(country_id, long_name, short_name) values(172, 'Camarines Sur', 'CAS');
insert into states(country_id, long_name, short_name) values(172, 'Camiguin', 'CAM');
insert into states(country_id, long_name, short_name) values(172, 'Capiz', 'CAP');
insert into states(country_id, long_name, short_name) values(172, 'Catanduanes', 'CAT');
insert into states(country_id, long_name, short_name) values(172, 'Cavite', 'CAV');
insert into states(country_id, long_name, short_name) values(172, 'Cebu', 'CEB');
insert into states(country_id, long_name, short_name) values(172, 'Compostela Valley', 'COM');
insert into states(country_id, long_name, short_name) values(172, 'Cotabato', 'NCO');
insert into states(country_id, long_name, short_name) values(172, 'Davao del Norte', 'DAV');
insert into states(country_id, long_name, short_name) values(172, 'Davao del Sur', 'DAS');
insert into states(country_id, long_name, short_name) values(172, 'Davao Oriental', 'DAO');
insert into states(country_id, long_name, short_name) values(172, 'Eastern Samar', 'EAS');
insert into states(country_id, long_name, short_name) values(172, 'Guimaras', 'GUI');
insert into states(country_id, long_name, short_name) values(172, 'Ifugao', 'IFU');
insert into states(country_id, long_name, short_name) values(172, 'Ilocos Norte', 'ILN');
insert into states(country_id, long_name, short_name) values(172, 'Ilocos Sur', 'ILS');
insert into states(country_id, long_name, short_name) values(172, 'Iloilo', 'ILI');
insert into states(country_id, long_name, short_name) values(172, 'Isabela', 'ISA');
insert into states(country_id, long_name, short_name) values(172, 'Kalinga', 'KAL');
insert into states(country_id, long_name, short_name) values(172, 'Laguna', 'LAG');
insert into states(country_id, long_name, short_name) values(172, 'Lanao del Norte', 'LAN');
insert into states(country_id, long_name, short_name) values(172, 'Lanao del Sur', 'LAS');
insert into states(country_id, long_name, short_name) values(172, 'La Union', 'LUN');
insert into states(country_id, long_name, short_name) values(172, 'Leyte', 'LEY');
insert into states(country_id, long_name, short_name) values(172, 'Maguindanao', 'MAG');
insert into states(country_id, long_name, short_name) values(172, 'Marinduque', 'MAD');
insert into states(country_id, long_name, short_name) values(172, 'Masbate', 'MAS');
insert into states(country_id, long_name, short_name) values(172, 'Metropolitan Manila', 'MNL (2)');
insert into states(country_id, long_name, short_name) values(172, 'Misamis Occidental', 'MSC');
insert into states(country_id, long_name, short_name) values(172, 'Misamis Oriental', 'MSR');
insert into states(country_id, long_name, short_name) values(172, 'Mountain', 'MOU');
insert into states(country_id, long_name, short_name) values(172, 'Negros Occidental', 'NEC');
insert into states(country_id, long_name, short_name) values(172, 'Negros Oriental', 'NER');
insert into states(country_id, long_name, short_name) values(172, 'Northern Samar', 'NSA');
insert into states(country_id, long_name, short_name) values(172, 'Nueva Ecija', 'NUE');
insert into states(country_id, long_name, short_name) values(172, 'Nueva Vizcaya', 'NUV');
insert into states(country_id, long_name, short_name) values(172, 'Occidental Mindoro', 'MDC');
insert into states(country_id, long_name, short_name) values(172, 'Oriental Mindoro', 'MDR');
insert into states(country_id, long_name, short_name) values(172, 'Palawan', 'PLW');
insert into states(country_id, long_name, short_name) values(172, 'Pampanga', 'PAM');
insert into states(country_id, long_name, short_name) values(172, 'Pangasinan', 'PAN');
insert into states(country_id, long_name, short_name) values(172, 'Quezon', 'QUE');
insert into states(country_id, long_name, short_name) values(172, 'Quirino', 'QUI');
insert into states(country_id, long_name, short_name) values(172, 'Rizal', 'RIZ');
insert into states(country_id, long_name, short_name) values(172, 'Romblon', 'ROM');
insert into states(country_id, long_name, short_name) values(172, 'Samar', 'WSA');
insert into states(country_id, long_name, short_name) values(172, 'Sarangani', 'SAR');
insert into states(country_id, long_name, short_name) values(172, 'Siquijor', 'SIG');
insert into states(country_id, long_name, short_name) values(172, 'Sorsogon', 'SOR');
insert into states(country_id, long_name, short_name) values(172, 'South Cotabato', 'SCO');
insert into states(country_id, long_name, short_name) values(172, 'Southern Leyte', 'SLE');
insert into states(country_id, long_name, short_name) values(172, 'Sultan Kudarat', 'SUK');
insert into states(country_id, long_name, short_name) values(172, 'Sulu', 'SLU');
insert into states(country_id, long_name, short_name) values(172, 'Surigao del Norte', 'SUN');
insert into states(country_id, long_name, short_name) values(172, 'Surigao del Sur', 'SUR');
insert into states(country_id, long_name, short_name) values(172, 'Tarlac', 'TAR');
insert into states(country_id, long_name, short_name) values(172, 'Tawi-Tawi', 'TAW');
insert into states(country_id, long_name, short_name) values(172, 'Zambales', 'ZMB');
insert into states(country_id, long_name, short_name) values(172, 'Zamboanga del Norte', 'ZAN');
insert into states(country_id, long_name, short_name) values(172, 'Zamboanga del Sur', 'ZAS');
insert into states(country_id, long_name, short_name) values(172, 'Zamboanga-Sibugay', 'ZSI');
insert into states(country_id, short_name) values(229, 'AL');
insert into states(country_id, short_name) values(229, 'AK');
insert into states(country_id, short_name) values(229, 'AZ');
insert into states(country_id, short_name) values(229, 'AR');
insert into states(country_id, short_name) values(229, 'CA');
insert into states(country_id, short_name) values(229, 'CO');
insert into states(country_id, short_name) values(229, 'CT');
insert into states(country_id, short_name) values(229, 'DE');
insert into states(country_id, short_name) values(229, 'FL');
insert into states(country_id, short_name) values(229, 'GA');
insert into states(country_id, short_name) values(229, 'HI');
insert into states(country_id, short_name) values(229, 'ID');
insert into states(country_id, short_name) values(229, 'IL');
insert into states(country_id, short_name) values(229, 'IN');
insert into states(country_id, short_name) values(229, 'IA');
insert into states(country_id, short_name) values(229, 'KS');
insert into states(country_id, short_name) values(229, 'KY');
insert into states(country_id, short_name) values(229, 'LA');
insert into states(country_id, short_name) values(229, 'ME');
insert into states(country_id, short_name) values(229, 'MD');
insert into states(country_id, short_name) values(229, 'MA');
insert into states(country_id, short_name) values(229, 'MI');
insert into states(country_id, short_name) values(229, 'MN');
insert into states(country_id, short_name) values(229, 'MS');
insert into states(country_id, short_name) values(229, 'MO');
insert into states(country_id, short_name) values(229, 'MT');
insert into states(country_id, short_name) values(229, 'NE');
insert into states(country_id, short_name) values(229, 'NV');
insert into states(country_id, short_name) values(229, 'NH');
insert into states(country_id, short_name) values(229, 'NJ');
insert into states(country_id, short_name) values(229, 'NM');
insert into states(country_id, short_name) values(229, 'NY');
insert into states(country_id, short_name) values(229, 'NC');
insert into states(country_id, short_name) values(229, 'ND');
insert into states(country_id, short_name) values(229, 'OH');
insert into states(country_id, short_name) values(229, 'OK');
insert into states(country_id, short_name) values(229, 'OR');
insert into states(country_id, short_name) values(229, 'PA');
insert into states(country_id, short_name) values(229, 'RI');
insert into states(country_id, short_name) values(229, 'SC');
insert into states(country_id, short_name) values(229, 'SD');
insert into states(country_id, short_name) values(229, 'TN');
insert into states(country_id, short_name) values(229, 'TX');
insert into states(country_id, short_name) values(229, 'UT');
insert into states(country_id, short_name) values(229, 'VT');
insert into states(country_id, short_name) values(229, 'VA');
insert into states(country_id, short_name) values(229, 'WA');
insert into states(country_id, short_name) values(229, 'WV');
insert into states(country_id, short_name) values(229, 'WI');
insert into states(country_id, short_name) values(229, 'WY');
insert into states(country_id, short_name) values(39, 'AB');
insert into states(country_id, short_name) values(39, 'BC');
insert into states(country_id, short_name) values(39, 'MB');
insert into states(country_id, short_name) values(39, 'NB');
insert into states(country_id, short_name) values(39, 'NL');
insert into states(country_id, short_name) values(39, 'NT');
insert into states(country_id, short_name) values(39, 'NS');
insert into states(country_id, short_name) values(39, 'NU');
insert into states(country_id, short_name) values(39, 'ON');
insert into states(country_id, short_name) values(39, 'PE');
insert into states(country_id, short_name) values(39, 'QC');
insert into states(country_id, short_name) values(39, 'SK');
insert into states(country_id, short_name) values(39, 'YT');